from sqlalchemy import Column, DateTime, Float, Integer, String
from database.db_init import Base


class Soil(Base):
    __tablename__ = "Soil"
    ID = Column(Integer, primary_key=True, index=True)
    RetrievalTime = Column(DateTime, unique=False)
    FarmID = Column(Integer, unique=False)
    AvgMoisture = Column(Float, unique=False)
    NitrogenContent = Column(Float, unique=False)
    PhosphorusContent = Column(Float, unique=False)
    PotassiumContent = Column(Float, unique=False)
    OtherIndicators = Column(String, unique=False)
